﻿CREATE TABLE [dbo].[UDS_Proc_Type] (
    [proc_id]   int NOT NULL,
    [proc_type] int NOT NULL,

    CONSTRAINT [PK_UDS_Proc_Type] PRIMARY KEY CLUSTERED (proc_id asc, proc_type asc),
    CONSTRAINT [FK_UDS_Proc_Type_Proc_ID] FOREIGN KEY (proc_id) REFERENCES dbo.UDS_Proc(proc_id)
);
GO

SET NOCOUNT ON;
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 2);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 3);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 4);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 5);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 6);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 7);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 8);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 9);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 10);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 11);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 12);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 13);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 14);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 15);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 16);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(1, 17);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(2, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(2, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(3, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(3, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(4, 9);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(5, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(5, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(6, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(6, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(7, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(7, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(8, 3);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(9, 3);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(10, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(10, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(11, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(11, 1);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(12, 0);
INSERT INTO dbo.UDS_Proc_Type (proc_id, proc_type) VALUES(12, 1);
GO